#!/bin/sh
echo "开始查询"
hive -e "select org_level,
	      code_type,
	      sum(amt) as sum_amt
	      from dw00.dw_order_info group by org_level,code_type;"
echo $?
echo "查询完成"